package cn.edu.sdjzu.xg23.kcsj01_backend.mapper;

import cn.edu.sdjzu.xg23.kcsj01_backend.entity.Employee;

import cn.edu.sdjzu.xg23.kcsj01_backend.entity.EmployeeAssPatent;
import cn.edu.sdjzu.xg23.kcsj01_backend.entity.EmployeeAssStandard;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface EmployeeAssStandardMapper {

    List<EmployeeAssPatent> getApplicantsByStandardId(Long id);
    // 根据专利id查询第一申报人
    Employee getFirstApplicantByStandardId (Long id);

    boolean save(@Param("list") List<EmployeeAssStandard> list);

    @Delete("DELETE FROM employee_standard WHERE standard_id = #{standardId}")
    int delete(Long standardId);
}
